SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_GetApplyFieldByNo] ( @JOL_Field_No INT )
AS 
    SELECT  a.JOL_Field_No ,
            b.JOL_Employer_Name ,
            a.JOL_Field_Purpose ,
            a.JOL_Field_Linkman ,
            a.JOL_Field_Contact ,
            a.JOL_Field_Action ,
            a.JOL_Field_ApplyTime ,
            a.JOL_Field_ApplyPosition ,
            a.JOL_Field_SeatNumber ,
            a.JOL_Field_IsProvideMultimedia ,
            a.JOL_Field_IsNeedInvoice ,
            a.JOL_Field_InvoiceBeginning ,
            a.JOL_Field_InvoiceProject ,
            a.JOL_Field_IsPaidMoney ,
            a.JOL_Field_AddTime ,
            a.JOL_Field_AddUser ,
            a.JOL_Field_UpdateTime ,
            a.JOL_Field_UpdateUser ,
            a.JOL_Field_VerifyStatus ,
            a.JOL_Field_VerifyUser ,
            a.JOL_Field_IsSendEmail ,
            a.JOL_Field_Remark ,
            a.JOL_ApplyField_EndTime ,
            a.JOL_ApplyField_Phone ,
            a.JOL_ApplyField_Fax ,
            a.JOL_ApplyField_Email
    FROM    dbo.JOL_ApplyField AS a
            INNER JOIN dbo.JOL_Employer AS b ON a.JOL_Field_ApplyCompany = b.JOL_Employer_Account
    WHERE   a.JOL_Field_No = @JOL_Field_No



GO
